<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"
    import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>系統設定詳細資料</title>
</head>
<body>
<% if(session.getAttribute("access") == "y" ){%>
<jsp:useBean id="mydb" scope="page" class="bean.ConDbBean"/>
<% 
	  String sql="select * from SYS_SETTING WHERE S_ID='"+request.getParameter("id")+"'";
	  ResultSet rs=mydb.executeQuery(sql);
	  rs.next();
	  String id = rs.getString(1);
	  String name = rs.getString(2);
      String value = rs.getString(3);
	  String desc = rs.getString(4);
	 
%>

<table width="600"  border="1" align="center" cellpadding="1" cellspacing="1" bordercolor="#999999">
                <div align="center">  系統設定詳細資料                </div>
                <tr bgcolor="#FFFFCC">
                  <td width="23%"><div align="right"><span class="gytext11"><font class=cherry></font>編號：</span></div></td>
                  <td width="77%"><div align="left"><span class="lggytext11"><%=id%> 
                  </span></div></td>
                </tr>
                <tr>
                  <td><div align="right"><span class="gytext11"><font class=cherry></font>設定名稱：</span></div></td>
                  <td><div align="left"><span class="lggytext11"><%=name%>
                  </span></div></td>
                </tr>
                <tr bgcolor="#FFFFCC">
                   <td><div align="right"><span class="gytext11"><font class=cherry></font>設定值：</span></div></td>
                  <td><div align="left"><span class="lggytext11"><%=value%>
                  </span></div></td>
                </tr>
                <tr>
                  <td><div align="right"><span class="gytext11">設定說明：</span></div></td>
                  <td><div align="left"><span class="lggytext11"><%=desc%>
                    </span></div></td>
                </tr>
              </table>
 

<%
  }
  else{
  	response.sendRedirect("../index.jsp"); //若沒有登入則回到index.jsp
  } 
  %>
</body>
</html>